package com.lxj.database.user;

import com.lxj.utils.L;


public final class UserInfoTable {
	
	private static final String TAG = "UserTable";
	
	public static final String _ID = "_id";
	public static final String USER_ID = "user_id";
	public static final String NAME = "user_name";
	public static final String BIRTHDAY = "user_birthday";
	public static final String PIC_ID = "user_pic_id";
	public static final String PIC_URL = "user_pic_url";
	public static final String SEX = "user_sex";
	public static final String INTRODUCTION = "user_introduction";
	private static final String DATABASE_TABLE_FRIENDS = "table_users";
	
	public static final String updateTable(int oldVersion, int newVersion)
	{
		String ret = null;
		return ret;
	}
	
	public static final String createTable()
	{
		String ret = "CREATE TABLE IF NOT EXISTS " + DATABASE_TABLE_FRIENDS + " ( " + _ID + " INTEGER PRIMARY KEY autoincrement, "
				+ USER_ID + " TEXT UNIQUE, " + NAME + " TEXT  , " + BIRTHDAY + " INTEGER  ,  " + PIC_ID + " INT, " + PIC_URL + " TEXT, " + SEX + " INT, " 
				+ INTRODUCTION + " TEXT)";
		L.e(TAG, ret);
		return ret;
	}
	
	public static final String getTableName()
	{
		return DATABASE_TABLE_FRIENDS;
	}
}